https://store-images.s-microsoft.com/image/apps.8166.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.cd6e2331-a608-4417-bfc0-055c4c4b9a59

DimensionPath

by CentralPath Solutions

Free trial badge

Extend and automate Business Central dimensions to do more, and to work together

Make Business Central dimensions smarter and more powerful


DimensionPath is a very low cost app that extends Business Central dimensions to do more, and to work together intelligently. Filter and analyze data across all 8 global/shortcut dimensions with our functionality to make them all work like global dimensions. Set up relationships between dimensions so the values work together, where one can dictate or limit the values for another. Automatically synchronize core system tables with related dimension values.


8 Global Dimensions
    • DimensionPath makes shortcut dimensions 3-8 behave like global dimensions, so they are readily available for filtering across the application
    • This includes updates to Financial Reports so that the 8 specified dimensions are directly available for row/column filters and filtering results with no need for analysis views

Dimension Relations
    • Define relations between dimensions, whereby a value for one dimension can dictate value(s) for other dimensions
    • For example, a Project dimension for SUPERBOWLAD could be defined with a relation to the MARKETING Department (another dimension)
      • With this structure, when the SUPERBOWLAD dimension is used anywhere, the Department will immediately be set to MARKETING and the user will be unable to change it (unless it is defined as a Flexible relationship)
    • Relationships will cascade through multiple levels if defined – i.e. A value for Dimension A dictates a value for Dimension B which in turn dictates a value for Dimension C

Dimension Subsets
    • Based on the value selected for one dimension, limit the options that are available for other dimension(s)
    • When dimension values are looked up for a master record or transaction, any invalid options (based on other dimension values) will be completely suppressed so the user only ever sees valid options and has no way to enter “bad” data (configurable – this can be relaxed if needed)
    • Dimension value options can also be restricted based on MULTIPLE other dimension values
      • If Dimension A is X and Dimension B is Y, then the values for Dimension C can be limited accordingly
    • This functionality replaces Business Central dimension combinations as an option with more functionality and tighter controls (preventing invalid data entry up front)

Dimension Synchronization
    • Link dimensions to master/supporting data within BC so that dimension values are automatically synchronized and attached
    • As an example, the Project table could be linked to a dimension called PROJECT, so that every Project created in BC automatically has a matching dimension code defined and attached to the project as a default dimension that users cannot change/remove
    • DimensionPath has special support here for Item Categories, where a multi-level hierarchy can have each level linked to a separate dimension
      • This enables items to be filtered by all levels of item categories, and carries every level (if defined) through to the G/L for analysis and reporting

Report Enhancements
    • A number of base reports have been extended or replaced to provide versions that support 8 global dimensions (eg. Trial Balance, Spread Global Dimension)

At a glance

https://store-images.s-microsoft.com/image/apps.42354.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.137a54b8-74e0-4894-944e-a06a383f6717
https://store-images.s-microsoft.com/image/apps.36315.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.3a0705ba-205e-4986-80ba-99f069c7a92f
https://store-images.s-microsoft.com/image/apps.1062.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.88be3055-a447-455b-b5ef-084a7513ec93
https://store-images.s-microsoft.com/image/apps.36531.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.f822dce9-4f75-41da-b417-eb794da91964
https://store-images.s-microsoft.com/image/apps.44219.89d84eef-3f25-4fcd-a50f-ebf58c646c1b.33e3dce1-a773-4408-ac17-927d920b5a0b.c4784185-3276-4927-b1fb-b785b1841d8b